﻿<%@ Page Title="" Language="C#" MasterPageFile= "~/View/Master.Master" AutoEventWireup="true" CodeBehind="Report_TrendAnalysisByrequisition.aspx.cs" Inherits="PresentationLayer.View.Reports.Report_TrendAnalysisByrequisition" %>

<%@ Register TagPrefix="CR" Namespace="CrystalDecisions.Web" %>
<%@ Register assembly="CrystalDecisions.Web, Version=13.0.2000.0, Culture=neutral, PublicKeyToken=692fbea5521e1304" namespace="CrystalDecisions.Web" tagprefix="CR" %>

<%@ Register src="../mainMenu.ascx" tagname="mainMenu" tagprefix="uc1" %>

<asp:Content ID="Content1" ContentPlaceHolderID="head" runat="server">
</asp:Content>
<asp:Content ID="Content2" ContentPlaceHolderID="ContentPlaceHolder1" runat="server">
 <table width="100%">
    <tr>
        <td style="height:auto;width:200px;vertical-align:top;">
            <uc1:mainMenu ID="mainMenu1" runat="server" />
        </td>
        <td>
         <div style="vertical-align:top;padding-left:20px;">
         <center><h2><u>Trend Analysis for Requisition </u></h2></center>

    <table width="600px">
    <tr>
        <td>Please choose 3 months:</td>
        <td>
              <asp:DropDownList ID="DropDownList3" runat="server" AppendDataBoundItems="True">
            <asp:ListItem Value="1">Jan</asp:ListItem>
            <asp:ListItem Value="2">Feb</asp:ListItem>
            <asp:ListItem Value="3">Mar</asp:ListItem>
            <asp:ListItem Value="4">Apr</asp:ListItem>
            <asp:ListItem Value="5">May</asp:ListItem>
            <asp:ListItem Value="6">Jun</asp:ListItem>
            <asp:ListItem Value="7">Jul</asp:ListItem>
            <asp:ListItem Value="8">Aug</asp:ListItem>
            <asp:ListItem Value="9">Sep</asp:ListItem>
            <asp:ListItem Value="10">Oct</asp:ListItem>
            <asp:ListItem Value="11">Nov</asp:ListItem>
            <asp:ListItem Value="12">Dec</asp:ListItem>
        </asp:DropDownList>
        &nbsp;&nbsp;
      
        </td>
    </tr>
    <tr>
        <td> Please select a category:   </td>
        <td>
         <asp:DropDownList ID="DropDownList1" runat="server" 
            DataSourceID="SqlDataSource3" DataTextField="CategoryName" 
            DataValueField="CategoryName">
        </asp:DropDownList>
        <asp:SqlDataSource ID="SqlDataSource3" runat="server" 
            ConnectionString="<%$ ConnectionStrings:SSISDBConnectionString %>" 
            SelectCommand="SELECT [CategoryName] FROM [Category]"></asp:SqlDataSource>
        </td>
    </tr>
    <tr>
        <td>Please select a department:</td>
        <td>
           <asp:DropDownList ID="DropDownList2" runat="server" 
            DataSourceID="SqlDataSource1" DataTextField="DeptName" 
            DataValueField="DeptName" AutoPostBack="True">
        </asp:DropDownList>
        <asp:SqlDataSource ID="SqlDataSource1" runat="server" 
            ConnectionString="<%$ ConnectionStrings:SSISDBConnectionString %>" 
            SelectCommand="SELECT [DeptName] FROM [Department]"></asp:SqlDataSource>   
        </td>
    </tr>
    </table>
    <asp:Button ID="btnSubmit" runat="server" Text="View Report" 
           onclick="btnSubmit_Click" />
    &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
            <asp:Button ID="Button1" runat="server" onclick="Button1_Click" 
                Text="Print Preview" />
       
    </div>



&nbsp;<hr />
    <div>
    
        <CR:CrystalReportViewer ID="CrystalReportViewer2" runat="server" 
            AutoDataBind="true" ToolPanelView="None" />
    </div>

    </td></tr></table>
</asp:Content>
